restore archivelog from backup piece

1. Back up all archived log filesrman> Backup Archivelog all delete input;Second: Various options for restore Archivelog0. According to the RAC thread, restore Archivelog from Logseq 6160 thread 2;1.restore

7_844605031.dbf RECID = 32 STAMP = 844886422Archived log file name =/home/oracle/PROD/export 8_844605031.dbf RECID = 33 STAMP = 844886590Archived log file name =/home/oracle/PROD/rj9_844605031.dbf RECID = 34 STAMP = 844886622Archived log file name =/home/oracle/PROD/201710_844605031.dbf RECID = 35 STAMP = 844887872Finished backup at 14-APR-14 Starting Control File Autobackup at 14-APR-14 Piece handle =/ho

: ========================================================== ==============================RMAN-03002: failure of recover command at 02/22/2010 12:44:56RMAN-06094: datafile 34 must be restoredon primary:-- Check the newly created datafile.SQL> SELECT FILE #, name from V $ datafile where creation_change #> = 28178572277879; -- orSQL gt; Set line 200SQL> set pagesize 9999SQL> Col name format A60SQL> SELECT FILE #, status, name from V $ datafile order by 1; file # status name----------------------

RMAN not always use incremental backup if it has archivelog backup too Refer: metalink 134214.1 if there is an archive log backup set, then RMAN will not necessarily select an incremental backup set. Let's use the following RECOVER command as an example: [SQL] RMAN> run {2>

Restore | original Prerequisite: The deleted table space is created when the database is in Archivelog mode Restore the specific actions as follows: sql> archive log list; Database Log Mode Archive mode Automatic Archival Enabled Archive Destination F:\oracle\ora92\RDBMS Oldest online log sequence 23 Next Log sequence to archive 25 Current log Sequence 25 sql>

;connect target Sys/[email protected]Rman>register database;Rman>report schema;Using Storage scripts1. Create a storage scriptC:\>rman catalog Rman/[email protected] target Sys/[email protected]Rman>create script Bak_database {Backup format= ' C:\temp\%d_%s.bak 'Database include current ControlfilePlus archivelog;SQL ' alter system archive log current ';}2. Run the script(1), run the storage script at the R

dbid = Restore Controlfile from Autobackup;ALTER DATABASE Mount;Restore database;Recover database Noredo;ALTER DATABASE open resetlogs;ALTER DATABASE open;In this example there is a dbid this can beSELECT * from V$database. But a database in the control file is broken can not open how to see it is in peacetime to write down this dbid.This is the simplest example of bac